/*
 Navicat Premium Data Transfer

 Source Server         : DNE
 Source Server Type    : MySQL
 Source Server Version : 50613
 Source Host           : den-db.ct3uknvsiwoi.us-east-1.rds.amazonaws.com
 Source Database       : dnedb

 Target Server Type    : MySQL
 Target Server Version : 50613
 File Encoding         : utf-8

 Date: 02/19/2014 00:08:33 AM
*/

SET NAMES utf8;
SET FOREIGN_KEY_CHECKS = 0;

-- ----------------------------
--  Table structure for `DigitoEstado`
-- ----------------------------
DROP TABLE IF EXISTS `DigitoEstado`;
CREATE TABLE `DigitoEstado` (
  `id` bigint(20) NOT NULL AUTO_INCREMENT,
  `digito` varchar(255) COLLATE utf8_bin DEFAULT NULL,
  `estado_id` bigint(20) NOT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `UK_1yefaov6lxjghsrfmb9jemwof` (`estado_id`),
  KEY `FK_1yefaov6lxjghsrfmb9jemwof` (`estado_id`),
  CONSTRAINT `FK_1yefaov6lxjghsrfmb9jemwof` FOREIGN KEY (`estado_id`) REFERENCES `Estado` (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=28 DEFAULT CHARSET=utf8 COLLATE=utf8_bin;

-- ----------------------------
--  Records of `DigitoEstado`
-- ----------------------------
BEGIN;
INSERT INTO `DigitoEstado` VALUES ('1', 'A', '1'), ('2', 'B', '2'), ('3', 'C', '3'), ('4', 'D', '4'), ('5', 'E', '5'), ('6', 'F', '6'), ('7', 'G', '7'), ('8', 'H', '8'), ('9', 'I', '9'), ('10', 'J', '10'), ('11', 'K', '11'), ('12', 'L', '12'), ('13', 'M', '13'), ('14', 'N', '14'), ('15', 'O', '15'), ('16', 'P', '16'), ('17', 'Q', '17'), ('18', 'R', '18'), ('19', 'S', '19'), ('20', 'T', '20'), ('21', 'U', '21'), ('22', 'V', '22'), ('23', 'W', '23'), ('24', 'X', '24'), ('25', 'Y', '25'), ('26', 'Z', '26'), ('27', '1', '27');
COMMIT;

SET FOREIGN_KEY_CHECKS = 1;
